Use this query if you are installing freshly or startign a new database (first delete your old one):

CREATE DATABASE highscores;
USE highscores;
CREATE TABLE pvphighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL);
CREATE TABLE mobhighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL);


Use this Query if you are updating from v0.1:

USE highscores;
RENAME TABLE highscores TO pvphighscores;
CREATE TABLE mobhighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL,);